-
Re: Count the number of times a text value appears in a single cell (or alternatively, split the cell)
@LEllis You're welcome! I know just what you mean, but I've found that all that trial and error usually helps me learn something that comes in handy later on. www.linkedin.com/in/juliefortney-pmp-sma…1 · -
Re: Count the number of times a text value appears in a single cell (or alternatively, split the cell)
Hi @LEllis, A good way to do this would be to create a sheet with each ABC value in a column, then add a column with a cross-sheet formula to count the number of times each value appears on your orig…1 · -
Re: Form -is there a way to display only available times (defined in drop down list) in the form
Yes! (maybe) I designed a solution like this for our team members to sign up for available time slots during a health fair. Data Shuttle is critical for this though - do you have the Data Shuttle pre…1 · -
Re: Index Match (?) to two different sheets (unique values)
I'm glad to help! I learned how to use Index/Match through the Community, so I'm glad to pass it on!2 · -
Re: Document Builder - attachments and generating the end doc
You can select specific recipients rather than selecting a contact column. The way they receive the Smartsheet alerts depends on their Smartsheet personal settings. Does that help?1 ·